Sales by Size Sheet 16


1. Right click on Hourly Avg Orders worksheet and select Duplicate. Rename the new sheet as Sales By Size.


2. Remove all the values from Marks shelf.

3. Drag and drop Pizza Size to Columns and Total Price to Rows.

4. Drag and drop Measure Values to Rows Shelf. Right click on Measure Values and select Edit Filter. From the list select:

 Avg Price MoM%

 Orders MoM%

 Sales MoM%

Unselect all other values. Click Ok.

5. Right click Measure Values and select Dual axis.

6. Under Marks, select Chart type = Bar for SUM(Quantity) and Chart type = Line for Measure Values.

7. Click on Color under Marks and select Edit colors. Assign the colors for values as below:

 Avg Price MoM% - #009867

 Orders MoM% - #747474

 Sales MoM% - #6b3b00

 Total Price - #dfbb43

8. Right click on Y axis label and select Edit axis. Under Range, select Fixed.

 Fixed Start = 0, Fixed End = 600,000

Under Axis Titles, leave the title blank.

9. Right click on X axis label and select Edit axis. Under Range, select Fixed.

 Fixed Start = -0.167, Fixed End = 0.420

Under Axis Titles, leave the title blank.

10. Click anywhere on the chart (on empty space), select Format. Click Lines, under Rows, Grid lines = None, Row Divider Pane = None. Under Columns, Column Divider, Pane = None.

10. Drag and drop Date Filter to Filters shelf and select only True option.

11. Click on Tooltip under marks and enter the following:

Pizza Size: <Pizza Size>

 Total Sales:<SUM(Total Price)>

 Sales MoM:<AGG(Sales MoM %)>

 Avg Orders:<AGG(Avg Orders By Day)>

 Orders MoM:<AGG(Orders MoM %)>

 Avg Price:<AGG(Avg Pizza Price)>

 Avg Price MoM:<AGG(Avg Price MoM %)>

Font = Tableau Book, Size = 8, Bold, Alignment = Left

12. Right click on Title, select Edit Title, add the title Sales by Size.


Follow the Gif files below for step by step instructions:





How to create Dual axis chart in Tableau